PhysicalCountLineItem

Entity Definition

Logical Name : PhysicalCountLineItem
Physical Name : TR_LTM_PHY_CNT

The line detail which records the number of units counted during the Physical Inventory. This is raw/ unedited data captured and will compared to the book stock to determine the actual unit and financial discrepancy for that ITEM.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitID (FK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_BSN_UN Identity integer TankReading(DO_RDG_TNK)
BusinessUnitID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_BSN_UN Identity integer PhysicalCountDocument(DO_CNT_PHY)
PhysicalCountDocumentID (FK)(PK) The identifier for the physical count document on which the actual item counts are recorded. ID_DCM_PHY_CNT Identity integer PhysicalCountDocument(DO_CNT_PHY)
PhysicalItemCountLineNumber (PK) The physical count line item. IC_CNT_PHY_ITM LineNumber smallint
LocationID (FK) A unique system assigned identifier for the Location. ID_LCN Identity integer InventoryLocation(LO_LCN_INV)
ItemID (FK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) StockItem(AS_ITM_STK)
TankID (FK) A unique identifier for this Tank ID_TNK Identity integer TankReading(DO_RDG_TNK)
TankProbeID (FK) A system assigned unique identifier for the TankProbe ID_PBE_TNK Identity integer TankReading(DO_RDG_TNK)
ReadingNumber (FK) A unique identifier for this particular reading on this TankProbe AI_RDG LineNumber smallint TankReading(DO_RDG_TNK)
UnitCount Number of units counted on this line during a phyiscal inventory. QU_ITM Quantity DECIMAL(9,3)
CountDateTime Date and time the count for this line item was performed. DT_CNT AuditDateTime datetime
EntryMethodCode A code that describes how the count was entered (for example, keyed or scanned). LU_MTH_ID_ENR Code2 char(2)

Relationships

Parent Entity Verb Phrase Child Entity
StockItem is managed via PhysicalCountLineItem
PhysicalCountDocument includes PhysicalCountLineItem
InventoryLocation is location for PhysicalCountLineItem
TankReading was performed via PhysicalCountLineItem
PhysicalCountLineItem is posted to ItemInventoryJournalEntry

Logical Views containing PhysicalCountLineItem

Logical View
Logical 02000 - Item Inventory and Stock Ledger View
Logical 02010 - Item Inventory - Adjustments View
Logical 02600 - Inventory Control Transaction View
Logical 04000 - Financial Ledger - Macro View
Logical 20050 - Forecourt Tank Gauge View